GrapeCity.CalcEngine.Functions Namespace > CalcAverageIfsFunction Class > Evaluate Method : Evaluate(Object[]) Method |
The args contains 2 - 255 items: average_range, criteria_range1,criteria1, [criteria_range2], [criteria2], ..
Average_range is one or more cells to average, including numbers or names, arrays, or references that contain numbers.
Criteria_range1, criteria_range2, ... are 1 to 127 ranges in which to evaluate the associated criteria.
Criteria1, criteria2, ... are 1 to 127 criteria in the form of a number, expression, cell reference, or text that define which cells will be averaged.
'Declaration Public Overloads Overrides Function Evaluate( _ ByVal args() As System.Object _ ) As System.Object
'Usage Dim instance As CalcAverageIfsFunction Dim args() As System.Object Dim value As System.Object value = instance.Evaluate(args)
public override System.object Evaluate( System.object[] args )
The args contains 2 - 255 items: average_range, criteria_range1,criteria1, [criteria_range2], [criteria2], ..
Average_range is one or more cells to average, including numbers or names, arrays, or references that contain numbers.
Criteria_range1, criteria_range2, ... are 1 to 127 ranges in which to evaluate the associated criteria.
Criteria1, criteria2, ... are 1 to 127 criteria in the form of a number, expression, cell reference, or text that define which cells will be averaged.
Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6